UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yLAgPGMre1zsQ79l1xY9svsuA/hq0iwZWgE+C9DwwpA='
WHERE
key_id = 'fd9cb7e8cc0d9054723923f6cd45a9ca5818638ea6824312d849470b37ac3be5'
AND (
token = 'yLAgPGMre1zsQ79l1xY9svsuA/hq0iwZWgE+C9DwwpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)