UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9CIe2kol+y7m/SStr2p6Cna35wu7PQjUhwelnzhASQ='
WHERE
key_id = 'dccf9b01e45201b711be5fb0bffd303d18e5f75c1248599df243ccdf5b9b19ad'
AND (
token = 'X9CIe2kol+y7m/SStr2p6Cna35wu7PQjUhwelnzhASQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)