UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XWV7jKB4+iZ2KC56Rs7QgY0Sor6q66K9LbLXqdTKc8='
WHERE
key_id = '6f5663a41f21116bddd26a8ad1a44875cc0b28600e4a9e024e195b59da171588'
AND (
token = '4XWV7jKB4+iZ2KC56Rs7QgY0Sor6q66K9LbLXqdTKc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)