UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnkpitP97FKALjRyP5v5RVQOW+RH2sgCMl+Sb3Y+94U='
WHERE
key_id = 'e20fdddf739887371fb94e0a1ae0d730c8594f8d84514c28c71644a8f6e85c89'
AND (
token = 'ZnkpitP97FKALjRyP5v5RVQOW+RH2sgCMl+Sb3Y+94U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)