UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9Npf7e1/uaOnbJlGdcT4d8ms1U7cro1lJ4XIEhOWI8='
WHERE
key_id = '9d9800fc03aaddb3b1d174dfd079f8ee9242d136ff8bd4265e069e0532f7c7d3'
AND (
token = 'a9Npf7e1/uaOnbJlGdcT4d8ms1U7cro1lJ4XIEhOWI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)