UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sSH1yaNgoIRcWp7IL0BCtU9o5AywXUk/1B9L7zqle8w='
WHERE
key_id = 'c414303c16fed64e37a5a89f4248374a933b0ae919d8415b8c9f4f2d6734adcd'
AND (
token = 'sSH1yaNgoIRcWp7IL0BCtU9o5AywXUk/1B9L7zqle8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)