UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vBORfwkgKmbUX1NvXPFDdO2iFO2sKd7UdlcaFpwSD4='
WHERE
key_id = 'd2729f4f8047a0a346362ce3cb963fd990ddb6eace199129c362cc65a5064759'
AND (
token = '6vBORfwkgKmbUX1NvXPFDdO2iFO2sKd7UdlcaFpwSD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)