UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUyTAP+JKu71s59pZzeup+MGEgpLrvcD8f5jTovtyTE='
WHERE
key_id = 'a109b9c8ac8e985fd5f7a4f53529f5e880f6c900ca11817e85ff04f97c6dd1be'
AND (
token = 'TUyTAP+JKu71s59pZzeup+MGEgpLrvcD8f5jTovtyTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)