UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zY2QqG0ZTUxS0cSy7Wrsm6aStM8gnTINAMSgImM/doU='
WHERE
key_id = '029395041067fcb26a8a8f4702e6edbe158cc0e162acf269b4de023d8784d4e8'
AND (
token = 'zY2QqG0ZTUxS0cSy7Wrsm6aStM8gnTINAMSgImM/doU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)