UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1iFfsxE0YeG3DDpY3HA8mjObULS6VYE0VsIdjFt33do='
WHERE
key_id = 'ba8086a825f0a31d897bffbaf8b92d26d269b7914029a3df4014adae635a4164'
AND (
token = '1iFfsxE0YeG3DDpY3HA8mjObULS6VYE0VsIdjFt33do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)