UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cgp3Pcz0DYO0P9h926k2ILRbM5uf01rOGcwQcLBhElI='
WHERE
key_id = '9260c2f28eddda4877cf98966af4bfeae64f3b5e6731afd8448c675c977d3886'
AND (
token = 'Cgp3Pcz0DYO0P9h926k2ILRbM5uf01rOGcwQcLBhElI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)