UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiMUXX3+7E2JFN9jH/UX/TKrVjQE8+tq7afZSU/hYQc='
WHERE
key_id = 'f877b52ff26c5f35bb8223c88e39f5e29b6ff639efa3b87761494e3de2108c00'
AND (
token = 'ZiMUXX3+7E2JFN9jH/UX/TKrVjQE8+tq7afZSU/hYQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)