UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JeCcFKfjDArOicZHKUh+HiaTt4ASQFrTnG3h5vXZso='
WHERE
key_id = 'e54b5bc1661b17adbed59eefc835416235c6b79aa2775f487c8d24df610be5f8'
AND (
token = '8JeCcFKfjDArOicZHKUh+HiaTt4ASQFrTnG3h5vXZso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)