UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CM5Fdiuv5Xqqzzl3FSAOguqv77menXPLY6WHexMRM5s='
WHERE
key_id = 'd8e571f2d51f3c13dc1a681e083adf673ca8e9558072d6c7a96a594e21f5b406'
AND (
token = 'CM5Fdiuv5Xqqzzl3FSAOguqv77menXPLY6WHexMRM5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)