UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kIRPvPBcu00lF1VN2DiOs6AORi1zEfaooBvMr4aPJC0='
WHERE
key_id = '8bc7dc31b888524565b82606a3d05cc4e0857bf41ee322ae4402ce94b05f92aa'
AND (
token = 'kIRPvPBcu00lF1VN2DiOs6AORi1zEfaooBvMr4aPJC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)