UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAYtdC+gOqwMzQyHWOnBfKKjDSc4pAspIINyGRK53j8='
WHERE
key_id = '63e9b306f7e24f1d52ef9ff0df6f6066f2a043c92623ded520eb89087d5aed87'
AND (
token = 'XAYtdC+gOqwMzQyHWOnBfKKjDSc4pAspIINyGRK53j8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)