UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1OofGaCoMPqw9WprZu2TZtMddXNgq9S8EYHCLBh8ps='
WHERE
key_id = '3af8171b162bd1b07e5ce49250d9e0880ad3782828cf072d7648fb42bf03f0e9'
AND (
token = 'Z1OofGaCoMPqw9WprZu2TZtMddXNgq9S8EYHCLBh8ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)