UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hEjE5SmKXksQuLwwAEC3jsq7HAk8Q3FRa+vckw0K3Rg='
WHERE
key_id = '2d1faf1b644a1eee587fa485ff3004c69b13831c867540528d5743781af25c76'
AND (
token = 'hEjE5SmKXksQuLwwAEC3jsq7HAk8Q3FRa+vckw0K3Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)