UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0liJFrGMXAw72SOSZpILsgOuacuYK7gjvXDVaL9Pts='
WHERE
key_id = 'c06ea1b2fb56d09be59ff2cfe0564f4cebd4f3ea119704d5a509526cc5092828'
AND (
token = 'C0liJFrGMXAw72SOSZpILsgOuacuYK7gjvXDVaL9Pts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)