UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GBZCMiTZeyoeO9rKYSvyeaZfDdVaEXQ5DsHISxxnyE='
WHERE
key_id = 'eb5c83ea5e0184dbaa9bde97dc0fdff478bb65bc430056aeb78e11f465969d92'
AND (
token = '6GBZCMiTZeyoeO9rKYSvyeaZfDdVaEXQ5DsHISxxnyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)