UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RBc7KMP2C6rssXpjnyJX/mSDSchPKmy5OWILTLL1CV0='
WHERE
key_id = 'ec8795fa8e84c6143f7a68d7c26ddaf27f60dc5c69fc9164c08b174fd31f43b4'
AND (
token = 'RBc7KMP2C6rssXpjnyJX/mSDSchPKmy5OWILTLL1CV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)