UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AmE8Ym8gxz0SRWHCfA2dsn8FCvfvoqLkHyy5YwhXNUU='
WHERE
key_id = '31cb5419ac0b8d00e1a80c6cec45b072f0c27f7590de57869b27fff971dfebab'
AND (
token = 'AmE8Ym8gxz0SRWHCfA2dsn8FCvfvoqLkHyy5YwhXNUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)