UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i5tH9RMlU3riQ18GTc53+rf8iOMdnRFEgZAOye5KtDs='
WHERE
key_id = 'd040910e7f2de1b9302d272bc9c2723316990e10c899740c344c0b82aa14acf1'
AND (
token = 'i5tH9RMlU3riQ18GTc53+rf8iOMdnRFEgZAOye5KtDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)