UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBaUUSOopJgph9W2fWy2xu/n5+7Vig7o6AsCy8xzr18='
WHERE
key_id = 'cc646727ede457057952f51a4bd622ad4c4fcf7f27f74c3ecf5e64950872f4d3'
AND (
token = 'mBaUUSOopJgph9W2fWy2xu/n5+7Vig7o6AsCy8xzr18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)