UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5kGABkE0KhfewvZ+TDc8NosQQdx/aftUElJMn00xyjA='
WHERE
key_id = '493c57f74e3b3edbf6b64cbd32b64489a7358893f3e889be72013abfa5dae2a1'
AND (
token = '5kGABkE0KhfewvZ+TDc8NosQQdx/aftUElJMn00xyjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)