UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZfT52y8kKN/Bkz4Tg9S8tCK16j003MPeNfBeLLroiE='
WHERE
key_id = 'b1c77e429850d9cd6109f508b23e54d5ad8653677281a54769344c6b294f0b42'
AND (
token = '5ZfT52y8kKN/Bkz4Tg9S8tCK16j003MPeNfBeLLroiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)