UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0vt7fbZGU46vVg4J7p2hFLKPOLYCAryYiYPVHCqqyQE='
WHERE
key_id = '4c5bdabefe4b123a45ba95f40c7e33359579a5a9cb46536f016d35ffd4c53694'
AND (
token = '0vt7fbZGU46vVg4J7p2hFLKPOLYCAryYiYPVHCqqyQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)