UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTnBeLN7HrZXCwYsddY1dOYKZv2qPfIU8CZYY3MXuaA='
WHERE
key_id = '8499e7bf80bdea72475fa18002e93b6a6951af09b6ade29d3ba95e20211c6b51'
AND (
token = 'tTnBeLN7HrZXCwYsddY1dOYKZv2qPfIU8CZYY3MXuaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)