UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdlYSRuhT+9KScE/mmKRO14RUIS98y1dUhDvYWmPl30='
WHERE
key_id = 'bfd477f7ffc5b375b6be4e91ae336cd33427a9982285b235af1412bf99f4dd42'
AND (
token = 'XdlYSRuhT+9KScE/mmKRO14RUIS98y1dUhDvYWmPl30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)