UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWAeHLOavdc/ahz3I8aEceyHH62GKK1P9cg0NbOBVnI='
WHERE
key_id = '06b457903137d229f4127cb91a76b030690b106daa6304077270590ff7beb2bc'
AND (
token = 'oWAeHLOavdc/ahz3I8aEceyHH62GKK1P9cg0NbOBVnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)