UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGT8KJJNb2eKI3Kjlth4Fg1BZNnDRYX9jnPJIj6yqJ0='
WHERE
key_id = 'd53688d9264f5a4ea2fc66a8190972302c75a4b52622bbf3e91a12982e9c87a6'
AND (
token = 'BGT8KJJNb2eKI3Kjlth4Fg1BZNnDRYX9jnPJIj6yqJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)